DELIMITER $$
DROP TRIGGER IF EXISTS sync_botiga;
CREATE TRIGGER sync_botiga
AFTER INSERT ON stockmovements
FOR EACH ROW
  BEGIN
    SET @EXIST = (SELECT COUNT(*) AS exist FROM m_product WHERE id_f_product=NEW.STK_IDProduct);
    IF (@EXIST = 1) THEN
      SET @IDS = (SELECT id_product_attribute FROM 2_ps_product_attribute  WHERE ean13= NEW.STK_IDProduct );
      IF (@IDS IS NULL) THEN
        SET @IDS = 0;
      END IF;

      SET @QUANT = (SELECT physical_quantity AS quant FROM 2_ps_stock
      WHERE id_warehouse=1
            AND id_product =  SUBSTRING(NEW.STK_IDProduct,3,6)
            AND id_product_attribute = @IDS);

      SET @NEWQUANT=@QUANT + NEW.STK_Quantity;
      IF ( @NEWQUANT < 0 ) THEN
        SET @NEWQUANT = 0;
      END IF;

      UPDATE  2_ps_stock  SET physical_quantity=@NEWQUANT,
        usable_quantity=@NEWQUANT
      WHERE id_warehouse=1
            AND id_product =  SUBSTRING(NEW.STK_IDProduct,3,6)
            AND id_product_attribute = @IDS;

      UPDATE 2_ps_stock_available SET quantity=quantity+NEW.STK_Quantity
      WHERE id_product = SUBSTRING(NEW.STK_IDProduct,3,6)
            AND id_product_attribute = @IDS;
    END IF;
  END;
$$
DELIMITER ;